最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

database - How to get the records from start with A to G in php and mysql

programmeradmin2浏览0评论

I have to show the records from A to G resutls from database. also tried the following code to show. Is there any mysql function available or should we use php to customize it.

Mysql query

SELECT *  FROM `wp_postmeta` WHERE `meta_key` = 'state' AND `meta_value` LIKE 'A%G'

Expected output

    States start from A thru G  States H thru J
Alabama                              Hawaii
Georgia                           Louisiana
发布评论

评论列表(0)

  1. 暂无评论