Title: markval's Replies | WordPress.org

---

# markval

  [  ](https://wordpress.org/support/users/markval/)

 *   [Profile](https://wordpress.org/support/users/markval/)
 *   [Topics Started](https://wordpress.org/support/users/markval/topics/)
 *   [Replies Created](https://wordpress.org/support/users/markval/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/markval/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/markval/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/markval/engagements/)
 *   [Favorites](https://wordpress.org/support/users/markval/favorites/)

 Search replies:

## Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Search in SQL db for text from phpMyAdmin](https://wordpress.org/support/topic/search-in-sql-db-for-text-from-phpmyadmin/)
 *  Thread Starter [markval](https://wordpress.org/support/users/markval/)
 * (@markval)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/search-in-sql-db-for-text-from-phpmyadmin/#post-969417)
 * Hi mrmist,
 * I have put the two colums as FULLTEXT but it still didn’t work so I have change
   my QUERY a bit to:
 * SELECT * FROM wp_posts
    WHERE post_title LIKE ‘%mySearchText%’ OR post_content
   LIKE ‘%mySearchText%’ AND post_status = ‘publish’ AND post_type = ‘post’
 * And now it works but I think it have a draw back. The first option could search
   for 2 words. Ex: (mySearchText no)
    While my new QUERY will search for the whole
   sentence instead of 2 separate word.
 * With the first QUERY I was hable to search in one column at a time but with no
   result. Even if the words were in the column with the same Case.
 * Any Idea how I could make it work for 2 separate words or more in one query?
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [SQL Query :: SELECT post from category ?](https://wordpress.org/support/topic/sql-query-select-post-from-category/)
 *  Thread Starter [markval](https://wordpress.org/support/users/markval/)
 * (@markval)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/sql-query-select-post-from-category/#post-968798)
 * Wow this will help me out a lot!
 * Thank you very much!
 * I do understand how it works now and it is pretty simple in some way!
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [I can’t post me catagories](https://wordpress.org/support/topic/i-cant-post-me-catagories/)
 *  [markval](https://wordpress.org/support/users/markval/)
 * (@markval)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/i-cant-post-me-catagories/#post-968786)
 * You either don’t have a post in your categories or you didn’t publish them.

Viewing 3 replies - 1 through 3 (of 3 total)