using wildcard character in query

[dstyles7]

i created a list box and text box with a command button below
the txt box is used to find info in the list box . i created a sql stament that does this. however i would like to create a wild card where if someone enters caracters from a-z it will pull up a record. below is my current sql statement


SQL = "SELECT LWFieldKey, LWTableLink, LWTableName, [LWFieldName_4], [Field Description] " & _
"FROM LWTABLES INNER JOIN LWFIELDS ON " & _
"LWTABLES.LWTableKey = LWFIELDS.LWTableLink " & _
"WHERE [LWFieldName_4] = '" & txtlwField & "' OR " & _
"[Field Description] = '" & txtlwDescription & "'"

[ronverdonk]

however i would like to create a wild card where if someone enters caracters from a-z it will pull up a record.

I suppose you mean a wildcard character like an asterisk (*).
In a MySQL query you can use the LIKE attribute. E.g.

# Search for all records with field starting with chars ABC
SELECT * FROM table WHERE field LIKE 'ABC%'
# Search for all records with field containing ABC
SELECT * FROM table WHERE field LIKE '%ABC%'
# Search for all record with field ending with ABC
SELECT * FROM table WHERE field LIKE '%ABC

When you are interested you could also use a regular expresion.

Ronald :cool:

[dlite922]

I suppose you mean a wildcard character like an asterisk (*).
In a MySQL query you can use the LIKE attribute. E.g.

# Search for all records with field starting with chars ABC
SELECT * FROM table WHERE field LIKE 'ABC%'
# Search for all records with field containing ABC
SELECT * FROM table WHERE field LIKE '%ABC%'
# Search for all record with field ending with ABC
SELECT * FROM table WHERE field LIKE '%ABC

When you are interested you could also use a regular expresion.

Ronald :cool:

I was curious, could you use the wild character with the IN() match.

For example could you do

WHERE name IN ("Tho%","%Mc%")

I tried it and it didn't work, is it LIKE IN ( ) or something?