mysql until作用,mysql-在SQL中选择UNTIL

I want to select rows until I found a certain value and it's not numeric so I cannot use > or <. how can i do this>

Example :

-----

Value

-----

45

434

348

213

543

3445

343

123

34345

I want to select all records before 543 (NOT ORDERED BY anything)

Thanks in advance

解决方案

This answer might be late, but since it's the first result on google with term of 'mysql select until' hope this might help someone.

What you can do is declare a marker and if you found the value needed, set the marker to any value other than NULL. Then we can use ISNULL for checking if we have reached the row.

SET @marker = NULL;

SELECT value FROM table1 WHERE ISNULL(@marker:=IF(value=543,value,@marker));