LIKE Operator syntax

[aas1611]

Hallo,

Under MS SQL there is this syntax:
LIKE '[0-9]%'

I've tried this but it gave me an empty result.
What is the equivalent of that in MySQL?

The reason is, I have a field that contains alphabets (words), empty, marks (?,',^, etc) and numbers. I only want to select the ones with numbers only, otherwise it has to be replaced with zero.

Any idea anyone?

 

[TonyGroves]

To replace non-numeric values with zero, you could use:
[tt]
SELECT
IF(
fld RLIKE '^[0-9]+$',
fld,
0
)
numfld
FROM tbl
[/tt]

RLIKE indicates the use of a regular expression. The ^ indicates the start of the string; the [0-9]+ means one or more digits; the $ means the end of the string.

You could also use REGEXP instead of RLIKE, and use a CASE expression instead of the IF.

 

[johnwm]

Google is your friend:

http://www.mysqlfreaks.com/statements/19.php

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller