What is the best statement to use when searching a table?

Let's say there are 10 columns and i am looking for any occurence of the string 'ee', what is the best way of doing that?

Thanks.

SELECT STATEMENT.

$sql = mysql_query (" SELECT blash blah WHERE so so = that

select * from mytable where column1 like '%ee%' or column2 like '%ee%' or .... or column10 like '%ee%'
or better
select * from mytable where concat(column1, column2, ... column10) like '%ee%'

select * from mytable where concat(column1, column2, ... column10) like '%ee%'

I like that one.

I'll give it a try and get back to you.

p.s. Is that case-sensitive???

No, it isn't. This will find strings containing either Ee or eE or EE or ee

Any idea on how to get case insensitive?

Ok. Apparantley it is possible to do a SELECT using a REGEX:

http://dev.mysql.com/doc/mysql/en/regexp.html

Unfortunately, i still can't understand REGEX properly.

How do i write a case insensitive SELECT statement for a string of characters that can come in the begininng, middle or end of the data?

Merci beaucoup.

Here it is:

SELECT * FROM column WHERE REGEXP '(ee)'.