Re: Searching in a mysql table

2001-08-03 Thread joe
I hope i'm asking in the right place, as i've asked around alot and haven't gotten an answer. Would it be inefficient to use the command "SELECT * FROM users_info WHERE name LIKE "%phil%" and company like "%" and address like "%";" Note the single % by itself. Would this slow down the s

Re: Searching in a mysql table

2001-08-03 Thread Werner Stuerenburg
joe schrieb am Freitag, 3. August 2001, 07:46:09: > Would it be inefficient to use the command "SELECT * FROM users_info WHERE > name LIKE "%phil%" and company like "%" and address like "%";" What use have > and company like "%" and address like "%" Omit it and you will be just as fine. If y