Dude, no need of the SQL mess! WP allows you to search through the post content or titles alphabetically using the search parameter.
So, use this solution instead…
global $wpdb;
$q = $_REQUEST['q'];
$posts = get_posts(array('s' => $q, 'post_type' => 'question', 'posts_per_page' => -1));
echo '<ul>';
foreach($posts as $post){
echo '<li><a href="'.get_permalink($post->ID).'">'.$post->post_title.'</a></li>';
}
echo '</ul>';
Put this in the AJAX handler function. It will work!
Related Posts:
- How do you properly prepare a %LIKE% SQL statement?
- $wpdb and MySQL Create Trigger
- wpdb->prepare function remove single quote for %s in SQL statment
- Alternative to mysql_real_escape_string
- Increment value (value = value+1) of $wpdb->update
- wpdb Custom Meta Data with 2 conditions
- wpdb prepare syntax
- MySQL LIKE not working
- Proper way to work with wpdb to get user’s firstname
- How to check for empty and not a failure
- Database: Custom table: sprintf value for DateTime column
- Converting mysql to $wpdb
- WP_USE_EXT_MYSQL
- wpdb insert and boolean fields
- Join new table with SQL query
- writing inner join in wpdb
- How to split the a table in database?
- MySQL Rank & $wpdb
- When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
- How do I join a $wpdb query with user meta using default value if not exist?
- How to translate this mySQL query to $wpdb query
- $wpdb select all meta for each post
- $wpdb to insert html form information
- Proper usage of $wpdb->update()?
- WordPress(wpdb class) and mysql stored procedures
- Can’t run database query
- Using WPDB->Insert()
- Active DB queries in WordPress?
- How to stop $wpdb from prepending database name
- WordPress $wpdb get posts from category and sort by custom meta
- How to get INSERT errors from $wpdb?
- Getting Error Trying to Create Table
- How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
- Understanding custom php that reads from WP MYSQL
- How to insert dash (-) into database using wpdb and new_to_publish hook?
- $wpdb->get_var multiple queries in one database check
- List users with the most posts in the last 30 days
- Insert two row in wordpress database
- WordPress $wpdb no result
- PHP variables in mysql query
- MySQL ‘duplicate entry’ error
- User set date and time from frontend doesn’t get stored into database
- Wpdb query with dynamic table name
- get posts whether meta_key exists or not
- when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
- How to search usermeta table
- How to add virtual column in wpdb get_result statement
- wpdb insert into point column in db
- WPDB delivers wrong results from complex queries
- $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
- CONCAT_WS in custom sql query
- Geographical proximity query using post_meta
- MySQL Select within WP Page template
- Saving custom term value to the database in new table
- why is $wpdb->update() causing a DB error from within wp_set_password()
- $wpdb->get_var returns 0
- Initialization of table in database using ‘CREATE … IF NOT EXISTS’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- mysql Foreign key constraint is incorrectly formed error
- mysql: SOURCE error 2?
- How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
- MySQL IF NOT NULL, then display 1, else display 0
- Repair all tables in one go
- ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
- Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
- Remove Primary Key in MySQL
- Error: Duplicate entry ‘0’ for key ‘PRIMARY’
- Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
- Search multiple meta keys at once
- query to create woocommerce products from images
- $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
- Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
- How to execute mulitple statement SQL queries using $wpdb->query?
- Error while importing database
- Ajax $wpdb not returning table data
- Can I restart MySQL engine when WordPress website is live?
- Why my wordpress loopback traffic while socket is setup?
- wpdb custom tables without plugin
- Update or insert meta key value – On Duplicate key update
- Defining the same price to all WooCommerce Products
- Have working sql query… trying to adjust it to use $wpdb
- Database Structure on Different Servers
- Export Yoast Keywords from MySQL/phpMyAdmin
- Same database; different WordPress
- How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
- Why won’t this wpdb get_results query return results?
- WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
- Upgrade DB Loop – WordPress DB Version Conflict
- What is my error trying to create a new table in the database?
- Using wpdb to connect to a different database is not working
- How to show result of sql query in a page?
- Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
- How can I get $wpdb to show MySQL warnings?
- Query does not filter duplicate _sku numbers
- wp_postmeta – lot of meta fields
- Delete posts with word count less than x number of words
- MySQL: get post_tag items that are tags (not SEO keywords)
- Batch Replace URLs in WordPress Database
- Uploading to WordPress Database