有什么方法可以从MySQL表中选择以某个字符/数字结尾的字段? [英] Any way to select from MySQL table where a field ends in certain character/number?

问题描述

我希望运行mysql_query，如果某个字段以数字结尾，我可以选择一行.例如:

I am hoping to run a mysql_query where I can select a row if a certain field ends in a number. For example:

<?php
$query = mysql_query("SELECT id FROM table WHERE [ID ENDS IN 0]");
$query = mysql_query("SELECT id FROM table WHERE [ID ENDS IN 1]");
$query = mysql_query("SELECT id FROM table WHERE [ID ENDS IN 2]");
$query = mysql_query("SELECT id FROM table WHERE [ID ENDS IN 3]");
//and so on...
?>

有没有办法做到这一点?任何帮助将是巨大的.谢谢！

Is there a way to do this? Any help would be great. Thank you!

推荐答案

SELECT ...
  WHERE somefield LIKE '%1'

这篇关于有什么方法可以从MySQL表中选择以某个字符/数字结尾的字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！