[SOLVED] query to check to see if string exist

[acctman]

can someone assist me with a query example that checks to see if a string exist.

 

$String = "Mike";

mysql query to check to see if $String exist in table Members, field Users...

 

[Mchl]

SELECT Users FROM Members WHERE Users LIKE '%Mike%'

 

If you get rows, string exists, if no...then it diesn't

 

 

This one will even tell you Yes or No

SELECT IF(COUNT(*) > 0,"Yes","No") AS stringExists FROM Members WHERE Users LIKE "%Mike%" LIMIT 1;

[rhodesa]

to extend on Mchl...this will return records like:

Mike Jones
John Mikel
Fred Amiken

[Mchl]

So? They all contain string "Mike" (well maybe apart from Amiken... not sure if LIKE can be case sensitive?)

 

[edit]

 

Sure it can!

 

SELECT Users FROM Members WHERE Users LIKE BINARY '%Mike%'