hi,

How do you use the LIKE operator on a table column using a wildcard?

e.g. Select * from tbl_employees WHERE 'Permanent' LIKE emptype;

emptype is a column name of type varchar but i want to add a wildcard to it like the following example:

Select * from tbl_employees WHERE emptype LIKE '%Permanent%';

Dont ask me why i want to do it like the first example - its just some wierd thing am trying to do!

The first example does work but cant seem to find the syntax if there is one to add a wildcard to the tbl column part.

I think... Maybe... Perhaps

george, mysql does not use the plus sign for concatenation

try to keep up, man

okay, i won't ask

but perhaps you might like to show us a few sample rows of data, and then show what the query should return

Oooh apologies!
What be thine concatenator?

where be thy fine manual?

[beam]I don't have one[/beam]
I don't have access to a MySQL database - I only know some theory, not practice
I suppose I could go look it up - but it'd probably be more beneficial for the OP to do so

the fine manual is located on the fine mysql web site

e.g. http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

you should really download and start practicing

Should being the operative word
The company I work for hardly uses it ~ I think it might just be our external site that has a tiny little MySQL db somewhere.
I guess I use this as my learning resource I try chip in a few cents here and there!

your company has nothing to do with what you have on your home computer

and yes, i said "should", not "could" -- it's a rather more forceful suggestion

The website link doesn't want to work - keeps timing out...
Silly question time: Where can I get a copy of MySQL that I can use on my home PC? In fact, I should probably start a newbie thread for this...

check your corporate firewall, mebbe dey don wan you skivin'...
on the mysql.com web site!!

You make me laugh Rudy
And yeah, I thought it'd be something simple like that MySQL is the free one, right? It'll work on XP Pro and XP Home / do I need IIS etc...

im askin cos i cnt b bothrd lukin it up myself.

Ach, I'll give the site a read later if I got time

IIS is used for web publishing, so no, you don't need it

*slaps forehead*
It's one of those days again - I'm all giddy - apologies