switchstatement (switchstatement) wrote in mysql,
switchstatement
switchstatement
mysql

selecting part of the data in a field

i have a field with a full street address, something like "1234 main st." is it possible to select just the numerical part of the data?

i ask because i need to compare that to another field. so it'd be real easy to just do something like

select * from `table` where (MAGIC, `address`) = `other_field`
  • Post a new comment

    Error

    default userpic
  • 2 comments