PDA

View Full Version : MYSQL regexp



robsonde
16-06-2003, 06:52 PM
tryin to do a search of a database in mysql and I dont understand the regexp system.

so far I have found that:

select * from table_test where bob regexp "one|two"
this will return any stuff containing "one" or "two".

select * from table_test where bob regexp "one two"
this will return any stuff containing "one two" exactly.

I want to search for one and two but not needing to be in that order.
eg "one and one is two" will match.


can anyone help??