Memory Jogger: Example of how to query the minimum and maximum values directly from the data via PHP and SQL.
- Follow me:
Categories
Archives
Tag Archives: SQL
Memory Jogger: SQL Query for minimum and maximum data values.
Posted in Memory Joggers Also tagged Actionscript, AMFphp, flash, Maximum, Minimum, MySQL, PHP, Remoting Leave a comment
Memory Jogger: Case Insensitve and “Like” MySQL queries.
Another one I keep having to remind myself how to do. If you want to do case insensitive SQL queries than just convert both target field and the string to the same case. SELECT * FROM ‘tableName’ WHERE UCASE(‘columnName’) = UCASE(“targetString”) If you want to use wild cards than use LIKE and % for wild [...]
