MySQL: REGEXP

[evdoxos]

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]

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

 

[evdoxos]

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.