[SOLVED] Wildcard in SELECT query

[master82]

I have a query, something similat to below...

[code]
SELECT * FROM table WHERE field1 = value AND field2= 'start text wildcard'
[/code]

Now what I need if possible is to use a wildcard type thing that selects only the values in that field that start with a certain value..

...for example select all the rows that have 'Welcome to' at the beginning

Is it possible?

[master82]

Nevermind... LIKE field '%value%'

thanks anyway