locked
mysql like RRS feed

  • Question

  • User-1432836131 posted

    hello ..

    i have this query in oracle

    select *
                FROM suppliers
                WHERE supplier_id LIKE '500_';

     

     this query will return all field that is 4 digit  ,begin with 500 and last digit can be 0-9.But I want last digit not euqal to ( 0 )

    Monday, January 23, 2012 7:44 AM

Answers

  • User-1360095595 posted

    AND supplier_id != '5000'

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 23, 2012 7:47 AM