MySQL: REGEXP

evdoxos · 04-07-2008, 05:13 PM

I want to make the following but using REGEXP:
SELECT * FROM table_Name WHERE (field_name LIKE 'key1' AND field_name LIKE 'key2' AND field_name LIKE 'key3');

Here is a way:
SELECT * FROM table_Name WHERE (field_name REGEXP ('key1') AND field_name REGEXP ('key2') AND field_name REGEXP ('key3'));
IS THERE A FASTER WAY?

**Eric** · 04-07-2008, 06:23 PM

Code:

SELECT *
FROM table_Name
WHERE field_name REGEXP('^key.*$')

evdoxos · 04-07-2008, 06:42 PM

I was meaning:

SELECT * FROM table_Name WHERE (field_name REGEXP ('a_word') AND field_name REGEXP ('an_other_word') AND field_name REGEXP ('a_third_word'));

where the words: a_word, an_other_word, a_third_word are generally completely different.

04-07-2008, 05:13 PM	THREAD STARTER #1 (permalink)
evdoxos NamePros Member Join Date: Mar 2008 Posts: 79	MySQL: REGEXP I want to make the following but using REGEXP: SELECT * FROM table_Name WHERE (field_name LIKE 'key1' AND field_name LIKE 'key2' AND field_name LIKE 'key3'); Here is a way: SELECT * FROM table_Name WHERE (field_name REGEXP ('key1') AND field_name REGEXP ('key2') AND field_name REGEXP ('key3')); IS THERE A FASTER WAY?

04-07-2008, 06:23 PM	#2 (permalink)
Eric Tech Support Join Date: Mar 2005 Posts: 4,944	Code: SELECT * FROM table_Name WHERE field_name REGEXP('^key.*$')

04-07-2008, 06:42 PM	THREAD STARTER #3 (permalink)
evdoxos NamePros Member Join Date: Mar 2008 Posts: 79	I was meaning: SELECT * FROM table_Name WHERE (field_name REGEXP ('a_word') AND field_name REGEXP ('an_other_word') AND field_name REGEXP ('a_third_word')); where the words: a_word, an_other_word, a_third_word are generally completely different. Last edited by evdoxos; 04-07-2008 at 06:46 PM.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)