i get no results using LIKE in mysql when names contain CAPS characters or not
Example
Names in database:
-Sopa de pescado
-Sopa de tomate
if i search for:
"Sopa" -> 2 results
"pes开发者_Go百科cado" -> 1 result
"sopa" -> 0 results :(
how can i fix?
You can convert all your search queries to lowercase and then use a query like this
SELECT * FROM Table_Name WHERE LOWER(Column_Name) LIKE '%pescado%';
You can use LOWER() function in WHERE part of your query. See here for function details.
Also, you may use COLLATION operator. In this case query will look in the following way:
SELECT *
FROM
table
WHERE
col_name COLLATE latin1_general_ci LIKE '%sopa%';
See here for details.
精彩评论