I am converting over to mySQL from Access 2.0 and I am having a little
trouble with a query. Here it is:
SELECT Max(WBS) AS LastOfWBS FROM Projects Where((WBS)) Like
txtEntryData(0).Text #%;
I am trying to get the last WBS ID starting with a particular letter
the user will type in the
-
Disclamer:
All you do with the suggestion in this mail is you responsibillity even
if your system will crash :)
-Original Message-
From: Jacque Scott [mailto:[EMAIL PROTECTED]
Sent: dinsdag 27 januari 2004 19:57
To: [EMAIL PROTECTED]
Subject: Using Wildcards in Query
It sounds as if you need to use a regular expression.
For very simple string comparisons, use =, as in _wbs='Fish'_
For more complex string comparisions with simple wildcards, use LIKE as
in _wbs LIKE %fish%
_For most complex comparisions, use a regular expression, as in _wbs
REGEXP .\d_
In
This worked great. Thank you very much.
Douglas Sims [EMAIL PROTECTED] 1/27/2004 12:23:59 PM
It sounds as if you need to use a regular expression.
For very simple string comparisons, use =, as in wbs='Fish'
For more complex string comparisions with simple wildcards, use LIKE as
in wbs LIKE