MySQL Forums
Forum List  »  Full-Text Search

search an array in mysql
Posted by: less less
Date: September 26, 2007 12:55PM

hello guys,

I've got a problem: How can I search for a string in an mysql-array?
For example: I want to select every 'lang' where 'names' = 'Paul'.
I know, it can be done by using WHERE names LIKE %Paul%, but I've read that this method has got a slow performance. Is there any way, to do it faster, beacause my database is very heavy.

id | lang | names
1 | UK | Paul;Armin;Joe;Sally
2 | DE | Georg;Amy;Paul;Don

Thanks!
Less

Options: ReplyQuote


Subject
Views
Written By
Posted
search an array in mysql
7440
September 26, 2007 12:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.