$nqry = mysql_query("select * FROM table_name where column_name BETWEEN 'AlertStopPressed' AND 'AlertStart'");
while($nftc = mysql_fetch_array($nqry)){
    echo $nftc['user_id']." - ".$nftc['alert_detail_id']." - ".$nftc['name']." - ".$nftc['alert_datetime']."<br>";
}


我必须将这些价值归类。
please see the image for more details

最佳答案

select * from table where columnname like 'startvalue%endvalue';


您的查询

$nqry = mysql_query("select * FROM table_name where column_name BETWEEN 'AlertStopPressed' AND 'AlertStart'") and columnname like 'startvalue%endvalue';

关于javascript - 我需要从一个表中获取记录,其中列值将以“某些值”开头,并以“另一种值”结尾,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/33579920/

10-11 01:28