What are the differences between backtick and single quote? Can I use IF statement in a query as above?

by

  1. In MySQL, backticks quote names, while single quotes create strings. If you have a column called select, MySQL would throw an syntax error when using this name without backticks — like in SELECT select FROM foo — as it would interpret it as keyword which may not occur there.

  2. This IF function can be used as a column specification in SELECT statements. See the MySQL reference.

  3. This function returns the value from the default column, if value is the empty string. Else it returns the value from value itself. The result will be called value. See the MySQL reference for details.

More Related Contents:

  1. PHP – Change value y,n in database [closed]
  2. how to select only one value sql
  3. How to create codeigniter dynamic menu from single table
  4. Sign in form always showing "Wrong Credentials"
  5. Comma separated numeric values – PHP CodeIgniter
  6. CodeIgniter – foreach loop
  7. How to insert multiple rows from array using CodeIgniter framework?
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  10. Find total number of results in mySQL query with offset+limit
  11. How can I Use Prepared Statements in CodeIgniter
  12. Grouping WHERE clauses in Codeigniter
  13. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  14. How to create Codeigniter language files from database?
  15. Trying to get property of non-object – CodeIgniter
  16. Codeigniter Transactions
  17. Inserting NOW() into Database with CodeIgniter’s Active Record
  18. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  19. Escaping SQL queries in Codeigniter
  20. PHP PDO and Mysql [closed]
  21. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  22. I want to use jquery nested sortable plugin with drag and drop in codeigniter using mysqli
  23. Set up the base url in codeigniter
  24. .htaccess issues: No input file specified
  25. CodeIgniter: Load controller within controller
  26. How to run the PHP script at scheduled time
  27. How to handle error for duplicate entries?
  28. MySql PHP select count of distinct values from comma separated data (tags)
  29. Difference between mysql_fetch_array and mysql_fetch_row?
  30. Aggregated query without GROUP BY

Leave a Comment