July 13th, 1999, 03:44 AM
I am trying to write a MySQL query which will find a single word (or string of characters) in a column. For example it should be able to find "capital high school" if the query is "high".
The query I've tried is
SELECT * FROM schools WHERE name = 'high';
I know that the % sign is the wildcard character but everytime I try using it the query fails. Can someone show me the EXACT syntax for the query I'm looking for?
new media arts
July 13th, 1999, 10:10 AM
SELECT * FROM schools WHERE name LIKE '%high%';
July 16th, 1999, 11:00 AM
How do you dice up the keyword sting? I'm trying to use php with mySQL?