Suppose that we have a list [10, 20, 4, 6, 9], and we want to write a sql query to get the data for all elements of the list, like
SELECT * FROM students WHERE id IN (10, 20, 4, 6, 9)
How to do that in Python? Actualy, it is very easy. Below are the list of techniques to do it:
Technique 1
id = [10, 20, 4, 6, 9] sql = 'select * from studens where id in %s' % str(tuple(id))
Change WordPress displayed author name for all comments
Thursday, November 6th, 2008Whenever you change the display name Users >> Your Profile >> Nickname, and set the “Display name publicly as”, it will only affect the newly posted comment by you. Actually, you can change the displayed author name for all comments.
You can change the displayed name of comment author for all comments using this sql statement:
Tags: Comment, WordPress
Posted in WordPress | No Comments »