[SOLVED] Help with LIKE %

[Riparian]

Is there a way I can limit the % wildcard to only one character

 

e.g.

$stock_number=100a

 

Select all where stock_number like $stock_number%

 

will also return stock number 1000a where all i want is 100a, 100b, 100c etc

 

Any help is really appreciated

 

[Mchl]

Use _ to match single character

[Riparian]

Thank you very much for the reply Mchl

 

Could you possibly give me an example where i could match the last digit to any alpha (not number)

 

I have been trying all afternoon using _ and things like REGEXP '^$model.{1}$' but I cant get the desired results.

 

Cheers

[Mchl]

SELECT '100a' RLIKE '100[a-z]';

-> 1

SELECT '1000' RLIKE '100[a-z]';

-> 0

[Riparian]

Thanks for the help.

 

I have tried every combination and only get Parse errors.

 

Could you please advise me where this is going wrong

 

$sql="select * from $table  WHERE $model_number RLIKE '$model_number[[a-z]]' and in_stock='T' ";

[Riparian]

Sorry ... Mistakenly added a $ to the Model_number field in the first reply

 

Thanks for the help.

 

I have tried every combination and only get Parse errors.

 

Could you please advise me where this is going wrong

 

$sql="select * from $table  WHERE model_number RLIKE '$model_number[[a-z]]' and in_stock='T' ";

[Mchl]

Try:

<?php
$sql="select * from $table  WHERE model_number RLIKE '{$model_number}[a-z]' and in_stock='T' ";

[Riparian]

Thank you very much for all your help.

 

It works exactly as required and I have learned something for the future.

 

Cheers