| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 34536 | 2003-06-16 06:52:00 | MYSQL regexp | robsonde (120) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 152920 | 2003-06-16 06:52:00 | 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?? |
robsonde (120) | ||
| 1 | |||||