using strpos in mysql? using strpos in mysql? database database

using strpos in mysql?


Using strpos you will get the position of that string and then trim the length you want

Use LOCATE('substring', 'mainstring') function

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_locate


You can use the LIKE 'operator' in SQL.

SELECT * FROM values WHERE name LIKE '%?%'


Please try LIKE operator for it

SELECT * from values where name LIKE '%?%';