http://snipplr.com/language/mysql/tags/where Recent snippets posted on Snipplr.com en-us Sat, 25 May 2013 23:09:06 GMT http://snipplr.com/view/35685/mysql-where/ The WHERE clause is used for extracting only those records that fulfill a specified criterion. If you wanted to select only certain entries of your table, then you would use the keyword WHERE. WHERE lets you specify requirements that entries must meet in order to be returned in the MySQL result. Those entries that do not pass the test will be left out. To get PHP to execute the statement above you must use the mysql_query() function. This function is used to send a query or command to a MySQL connection. The following example selects all rows from the Persons table where FirstName='Peter':

]]> Fri, 11 Jun 2010 12:48:29 GMT http://snipplr.com/view/35685/mysql-where/ http://snipplr.com/view/20033/conditional-string-replace/ as a note to self... in order to find it laters... This will only alter the value of fieldname if the conditions in the WHERE clause are met. With replace we only replace a certain string within fieldname with the replace_with string

]]> Tue, 22 Sep 2009 09:11:41 GMT http://snipplr.com/view/20033/conditional-string-replace/