[Solved] Searching for sub-strings
Posted: Sat Sep 03, 2005 11:34 am
I want to find all the records in a database that begin with "a", "b" etc and count the results.
Something like:
SELECT * FROM table WHERE word STARTS_WITH "a" (!)
I am sure this is trivial but I can't find the right WHERE clause to use.
Any help gratefully received.
David
Something like:
SELECT * FROM table WHERE word STARTS_WITH "a" (!)
I am sure this is trivial but I can't find the right WHERE clause to use.
Any help gratefully received.
David