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
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.