Functions for Use in SELECT and WHERE Clauses A select_expression or where_definition in a SQL statement can consist of any expression using the functions described next. An expression that contains - Selection from MySQL Reference Manual [Book]

The following statement is invalid because it contains one list of nine values, rather than three lists of three values each: the information string can be obtained by invoking the mysql_info() function. Previous HANDLER Syntax ; Home MySQL 5.6 Reference Manual Including MySQL NDB CONTAINS is a predicate used in the WHERE clause of a Transact-SQL SELECT statement to perform SQL Server full-text search on full-text indexed columns containing character-based data types. CONTAINS can search for: A word or phrase. The prefix of a word or phrase. A word near another word. MySQL FIND_IN_SET() returns the position of a string if it is present (as a substring) within a list of strings. The string list itself is a string contains substrings separated by ',' (comma) character. This function returns 0 when search string does not exist in the string list and returns NULL if either of the arguments is NULL. Syntax: I am copying the rest of the list with this so that everyone may benefit from the discussion. If your routine modifies data, in other words if it does SQL Update, Insert or Delete but your routine definition says only "CONTAINS SQL", I would expect your routine to fail at runtime. What that status of this? I didn't know about this bug, and so I created a database with a dash in the name, and now I want to delete it. Has this bug been fixed in the newest version of Mysql? IN() function. MySQL IN() function finds a match in the given arguments. Syntax: expr IN (value,) The function returns 1 if expr is equal to any of the values in the IN list, otherwise, returns 0. If all values are constants, they are evaluated according to the type of expr and sorted. The search for the item then is done using a binary search.