Search a mySQL table

[Anon]

What kind of query should I make to my DB to get all rows where a "ST...." is present?

Thank you guys/gals

Pepe -Spain-

[Anon]

How many columns are you looking for "ST..." in??

Something like this will search a text column for any records starting with ST...

SELECT * FROM your_table WHERE text_column LIKE 'ST%';

If you want to search multiple columns, then you have to specify each one...

SELECT * FROM your_table WHERE text_column_1 LIKE 'ST%' AND text_column_2 LIKE 'ST%' ....

By default, most columns are case insenstive. You have to give the keyword BINARY when creating them or use blobs for case sensitive searching. So if you want to find ST, but not st, St, or sT, then use BINARY or blobs...

---John Holmes...

[Anon]

As of mysql 3.23 you can make searches case-sensitivy by add the keyword BINARY in the query. You nolonger have to define it at create time.

SELECT * FROM table WHERE id=2 AND BINARY field LIKE "a%";